IF exists(SELECT * FROM dbo.sysobjects WHERE name='geefStartDatumSR' AND xtype='P') 
BEGIN
	DROP PROCEDURE geefStartDatumSR
END
GO

create procedure geefStartDatumSR
(@jaar varchar(4),
 @datum datetime)
as
update alleGestarteLln
set verlatenSROp = @datum
select * from alleGestarteLln 
where left(stamNrSR,2)= left(@jaar,2)